www.gusucode.com > PHP展示型企业网站模板米拓整站源码 1.0PHP源码程序 > PHP展示型企业网站模板米拓整站源码 1.0/MetInfozs_v1.0/MetInfozs_v1.0/admin/app/batch/csvup.php

    <?php
$depth='../';
require_once $depth.'../login/login_check.php';
setlocale(LC_ALL,array('zh_CN.gbk','zh_CN.gb2312','zh_CN.gb18030'));
$codeold='gbk';
$codenew='utf-8';
$classflie=explode('_',$fileField);
$classflie=explode('-',$classflie[count($classflie)-1]);
$class1=$classflie[0];
$class2=$classflie[1];
$class3=$classflie[2];
$class=$class3?$class3:($class2?$class2:$class1); 
$classcsv=$db->get_one("select * from $met_column where id=$class");
if(!$classcsv){
metsave("../app/batch/contentup.php?anyid=$anyid&lang=$lang",$lang_csvnocolumn,$depth);
}
$table=moduledb($classcsv['module']);
$file = fopen($flienamecsv,'r');
$fdata=fgetcsv($file);
foreach($fdata as $key=>$val){
	if(iconv($codeold,$codenew,$val)==$lang_columnhtmlname){$staticnum=$key;}
}
$numcsv=0;
while ($data = fgetcsv($file)){
	$staticone=iconv($codeold,$codenew,$data[$staticnum]);
	if($staticone!=NULL){
		$static[$numcsv+1]=$staticone;
		$static_copy[]=$staticone;
	}
	$dataqrray[]=$data;
	$numcsv++;
}  
fclose($file); 
@file_unlink($flienamecsv); 
if($static){
	foreach($static_copy as $key=>$val){
		$shift=array_shift($static_copy);
		if(array_search($shift,$static_copy)==NULL){
			if($shift==$static_copy[0]){
					$num=$key+2;
					metsave("../app/batch/contentup.php?anyid=$anyid&lang=$lang","{$lang_csverror1}{$num}",$depth);
			}
		}
		else{
			$num=$key+2;
			metsave("../app/batch/contentup.php?anyid=$anyid&lang=$lang","{$lang_csverror1}{$num}",$depth);
		}
	}
	$query="select id from $met_column where (classtype=1 or releclass!=0) and foldername='$classcsv[foldername]'";
	$sameflie=$db->get_all($query);
	foreach($sameflie as $key=>$val){
		$classquery.=$key==0?"class1='$val[id]'":" or class1='$val[id]'";
	}
	$query="select filename from $table where ($classquery) and filename !=''";
	$static_temp=$db->get_all($query);
	$i=1;
	foreach($static_temp as $key=>$val){
		$static_file[$i++]=$val['filename'];
	}
	foreach($static_file as $key=>$val){
		$num=array_search($val,$static)+1;
		if($num!=1){
			metsave("../app/batch/contentup.php?anyid=$anyid&lang=$lang","{$lang_csverror2}{$num}",$depth);
		}
	}
}
$numcsvcopy=0;
foreach($dataqrray as $key=>$val){
$numcsvcopy++;
$title=iconv($codeold,$codenew,$val[0]);
$items=1;
$querycsvpara=array();
if($classcsv['module']!=2){
	$querypara = "select * from $met_parameter where lang='$lang' and module='$classcsv[module]' and (class1='0' or (class1='$class1' and class2='$class2' and class3=0) or (class1='$class1' and class2='$class2' and class3='$class3') or (class1='$class1' and class2=0 and class3=0)) order by no_order";
	$csvpara=$db->get_all($querypara);
	foreach($csvpara as $key1=>$val1){
	if($val1['type']!=5){
		$querycsvpara[]="paraid   ='".iconv($codeold,$codenew,$val1[id])."',
						 info     ='".iconv($codeold,$codenew,$val[$items])."',
						 imgname  ='',
						 module   ='$classcsv[module]',
						 lang     ='$lang'";
		$items+=1;
		}
	}
}
$filename=iconv($codeold,$codenew,$val[$items]);
$items+=1;
$columnmtitle=iconv($codeold,$codenew,$val[$items]);
$items+=1;
$keywords=iconv($codeold,$codenew,$val[$items]);
$items+=1;
$description=iconv($codeold,$codenew,$val[$items]);
$items+=1;

$content=iconv($codeold,$codenew,$val[$items]);;
$items+=1;
if($metadmin['productother']&&$classcsv['module']==3){
$metadminnum=$metadmin['productother'];
}
if($metadmin['imgother']&&$classcsv['module']==5){
$metadminnum=$metadmin['imgother'];
}
if($metadminnum!=0){
	$cvsother=1;
	while($cvsother<=$metadminnum){
		$contenttemp='content'.$cvsother;
		$$contenttemp=iconv($codeold,$codenew,$val[$items]);;
		$items+=1;
		$cvsother++;
	}
}

$addtime=$updatetime=date('Y-m-d H:i:s');
$query = "INSERT INTO $table SET
					  title              = '$title',
					  description        = '$description',
					  ctitle       		 = '$columnmtitle',
					  keywords           = '$keywords',
					  content            = '$content',
					  class1             = '$class1',
					  class2             = '$class2',
					  class3             = '$class3',
					  issue              = '$metinfo_admin_name',
					  addtime            = '$addtime', 
					  updatetime         = '$updatetime',
					  filename           = '$filename',
					  recycle            = '-1',
					  lang          	 = '$lang'";
if(($metadmin[productother]||$metadmin[imgother])&&($classcsv['module']==3||$classcsv['module']==5))$query .=",
                      content1            = '$content1',
					  content2            = '$content2',
					  content3            = '$content3',
					  content4            = '$content4'
					  ";

$db->query($query);
$id=mysql_insert_id();
if($numcsvcopy==1){$fid=$id;}
if($numcsv==$numcsvcopy){$lid=$id;}
foreach($querycsvpara as $key2=>$val2){
    $query = "INSERT INTO $met_plist SET listid ='$id',$val2";
    $db->query($query);
}
}
if($numcsv){
	if($classcsv['module']==2){
		metsave("../app/batch/contentup.php?anyid=$anyid&lang=$lang",$lang_jsok,$depth);
	}
	metsave("../app/batch/fileup.php?anyid=$anyid&lang=$lang&class1=$class1&class2=$class2&class3=$class3&fileup=1&numcsv=$numcsv&fid=$fid&lid=$lid&action=do&page=1",$lang_jsok,$depth);
}
else{
	metsave("../app/batch/contentup.php?anyid=$anyid&lang=$lang",$lang_csvnodata,$depth);
}
?>